Table parking_lots { lot_id int [pk, increment] name varchar [not null] address varchar total_capacity int }

Table parking_floors { floor_id int [pk, increment] lot_id int [ref: > parking_lots.lot_id] floor_number int [not null] capacity int }

Table parking_spots { spot_id int [pk, increment] floor_id int [ref: > parking_floors.floor_id] spot_number varchar [not null] spot_type varchar [not null] // HANDICAPPED, COMPACT, LARGE, EV, MOTORCYCLE status varchar [not null] // AVAILABLE, OCCUPIED }

Table tickets { ticket_id int [pk, increment] spot_id int [ref: > parking_spots.spot_id] license_plate varchar [not null] entry_time timestamp [not null] exit_time timestamp amount_charged decimal status varchar [not null] // ACTIVE, PAID, EXPIRED }

Table payments { payment_id int [pk, increment] ticket_id int [ref: > tickets.ticket_id] transaction_ref varchar [unique, not null] amount decimal [not null] payment_method varchar [not null] // CREDIT_CARD, CASH_KIOSK, MOBILE_PAY payment_time timestamp [not null] }

Table parking_rates { rate_id int [pk, increment] lot_id int [ref: > parking_lots.lot_id] spot_type varchar [not null] hourly_rate decimal [not null] weekend_multiplier decimal [default: 1.0] }

This content is reserved for Premium Members.